Hi,
I have the following data set below:
File Name 1A | File Name 1B |
x | x |
x | x |
x | x |
x | x |
x | x |
x | x |
x | x |
File Name 2A | File Name 2B |
x | x |
x | x |
x | x |
File Name 3A | File Name 3B |
x | x |
x | x |
x | x |
and would like to transform it to look like this:
COLUMN 1 | COLUMN 2 |
File Name 1A | File Name 1B |
File Name 1A | File Name 1B |
File Name 1A | File Name 1B |
File Name 1A | File Name 1B |
File Name 1A | File Name 1B |
File Name 1A | File Name 1B |
File Name 1A | File Name 1B |
File Name 1A | File Name 1B |
File Name 2A | File Name 2B |
File Name 2A | File Name 2B |
File Name 2A | File Name 2B |
File Name 2A | File Name 2B |
File Name 3A | File Name 3B |
File Name 3A | File Name 3B |
File Name 3A | File Name 3B |
File Name 3A | File Name 3B |
Basically, change all the x's to 'File Name XX' when it hits a new 'File Name XX' value.
Thanks for your assistance.
Kind regards,
Daniel
Solved! Go to Solution.
Sorry no worries, this article solved my issue:
Thanks,
Daniel