Hello all,
My data looks like below.
row 1 is just a label to show this example
name column(s) are A through L
Number column(s) are M through Q
state column(s) are M through Q
info column(s) are M through Q
comments column(s) are M through Q
value column is R through W
What I would like is each name data in one row followed by columns number, state, info and comments
name 1 number state info comments
Each "group" of Name rows occupy four rows but "name" is only in first of the four rows (and are repeated thousands of times)
Thanks for any suggestions
excel sheet:
<tbody>
</tbody>
My data looks like below.
row 1 is just a label to show this example
name column(s) are A through L
Number column(s) are M through Q
state column(s) are M through Q
info column(s) are M through Q
comments column(s) are M through Q
value column is R through W
What I would like is each name data in one row followed by columns number, state, info and comments
name 1 number state info comments
Each "group" of Name rows occupy four rows but "name" is only in first of the four rows (and are repeated thousands of times)
Thanks for any suggestions
excel sheet:
name | |||||||||||||||||
name1 | Number: | value1 | |||||||||||||||
name1 | state | value 2 | |||||||||||||||
name1 | info | value3 | |||||||||||||||
name1 | comments | value4 | |||||||||||||||
name2 | Number: | value5 | |||||||||||||||
name2 | state | value6 | |||||||||||||||
name2 | info | value7 | |||||||||||||||
name2 | comments | value8 | |||||||||||||||
name3 | Number: | value9 | |||||||||||||||
name3 | state | value10 | |||||||||||||||
name3 | info | value11 | |||||||||||||||
name3 | comments | value12 | |||||||||||||||
name4 | Number: | value13 | |||||||||||||||
name4 | state | value14 | |||||||||||||||
name4 | info | value15 | |||||||||||||||
name4 | comments | value16 |
<tbody>
</tbody>