Hi, I've tried searching with no luck,
I have an awful looking set of data which looks something like the left where sets of data repeat every three lines.
I've got to the point where I have an index column that repeats itself with Record ID and a formula which uses Mod([RecordID]-1,3)=1.
However I can't wrap my head around how to use this repeating index of 1-3 to spread out horizontally from the current data.
The actual data has repeating sets of data which stretch 16 columns and 3 rows.
Thank you in advance and happy new year everyone.
Solved! Go to Solution.
Hi, @IH
FYI.
| Input | ||||||||
| A | B | C | ||||||
| Age | Gender | Ethnicity | ||||||
| ID | Weight | Eyecolor | ||||||
| Name | Height | Interests | ||||||
| 35 | Male | Asian | ||||||
| brad123 | 72 | Brown | ||||||
| Brad | 180 | Football | ||||||
| 27 | Male | Caucasian | ||||||
| riley345 | 80 | Blue | ||||||
| Riley | 190 | Basketball | ||||||
| Output | ||||||||
| Age | Gender | Ethnicity | ID | Weight | Eyecolor | Name | Height | Interests |
| 35 | Male | Asian | brad123 | 72 | Brown | Brad | 180 | Football |
| 27 | Male | Caucasian | riley345 | 80 | Blue | Riley | 190 | Basketball |
******
If can help you get your want, please mark it as a solution and give a like for more share.
@flying008- That's an excellent tool!
Also, building off of @caltang's, here is another variant for the solution:
