I have a csv file (without headers). Col A is Product Name and Col B onwards contains special codes. Each separate code is shown in a subsequent column i.e If there are 3 codes the first three columns are used; if there are 4 codes, the first four columns etc.
My current data looks something like this :-
Col A Col B Col C Col D
a 1 2 4
b 2 3
c 2 4 5
d 1 5
I need to arrange the data in the following format :-
Col A Col B Col C Col D Col E Col F
Product 1 2 3 4 5
a 1 2 – 4 –
b – 2 3 – –
c – 2 4 5
d 1 – – – 5
I need the grid to show all potential codes and so my headers wil run from 1 – 40 (Column AO) as there are 40 potential codes and hundreds or rows of data. Does anyone have an idea how I should go about this ?
Many thanks
Robert
