Hi Folks,
I've been searching on here as well as various search engines and I can't find what I'm looking for so I'm making a new thread.
I have a spreadsheet that has multiple rows of data. However, I need to break up each row, because at the end, there are columns that need to be split up over different rows. the hitch is that in each row, columns A:R need to stay with the columns S and beyond. Even worse, the number of columns after R is not consistent. There can be 4 columns or there can be 20 columns. The columns are grouped by 4 and the last column in each set is a timestamp. soooo, I've attached a sample file, but I'll try to make a visual so you don't have to open the file.
colA colB colC colD colE ... ColR ColS colT colU colV colW colX colY colZ
txt1 txt2 txt3 txt4 ID 1 ... int1 var1 var1 var1 var1 var2 var2 var2 var2
txt1 txt2 txt3 txt4 ID 1 ... int2 var1 var1 var1 var1 var2 var2 var2 var2
txt1 txt2 txt3 txt4 ID 2 ... int1 var1 var1 var1 var1
txt1 txt2 txt3 txt4 ID 3 ... int1
Hopefully that paints a helpful picture. In colE you can see that there are 3 different IDs. ID 1, has two different INTs in colR and different variables across the remaining columns. What I'm looking to do is create a second line for those extra variables in colW-colZ. Hopefully that makes sense
The end result would look like this:
colA colB colC colD colE ... ColR ColS colT colU colV
txt1 txt2 txt3 txt4 ID 1 ... int1 var1 var1 var1 var1
txt1 txt2 txt3 txt4 ID 1 ... int1 var2 var2 var2 var2
txt1 txt2 txt3 txt4 ID 1 ... int2 var1 var1 var1 var1
txt1 txt2 txt3 txt4 ID 1 ... int2 var2 var2 var2 var2
txt1 txt2 txt3 txt4 ID 2 ... int1 var1 var1 var1 var1
txt1 txt2 txt3 txt4 ID 3 ... int1
sampledata.xlsx removed, please see post #3
sample file attached. Thanks in advance for any help.
-joel
Bookmarks