On Sep 20, 9:46*am, Adrienne Miller wrote:
Hello,

I need help! *I have spreadsheets with tons of data and I am looking
to write a macro to do what i need. *I have varrying number of data
within a cell and need to seperate them out. *I current do text to
columns to seperate into seperate columns. *Then I count the number of
columns in each row, and then insert that number of rows below and
then copy and paste special transpose to get them into their own
rows. *The are in the fourth column of data. *I then copy down the
first three columns over and over for each value.

I do very beginner code writing as this is not my training or job, but
I can usually figure it out. *I am stuck on this one, any help is
appreciated.

Thanks,
A

Send your file with a complete explanation and examples to dguillett1
@gmail.com