Hi all,
Can anybody please help, i have a spreadsheet with thousands of lines
of changes to a file (below) - i want to create 2 lines 'Changed
from'
& 'Changed to'.. basically find the ID in Col B that is a ‘From’ and
collate all these into the 1st row id (or to a new worksheet) and do
the same for the ‘to’…
The cols go to from ‘A’ to ‘AN’ and there is a varying number of
Changes from & to..
This is what I have.. ..
Col A COL B COL C COL D COL E … COL AN
Change348 from FSYO00070 Tankersley
Change348 to FSYO00070 Brampton
Change349 from FSYO00070
Change349 to FSYO00070 N/A
Change350 from FSYO00070 YT5 EZ
Change350 to FSYO00070 T70 OKA
Change351 from FSYO00070
Change351 to
FSYO00070
TBC
Change352 from
FSYO00070
F40S11
Change352 to
FSYO00070
F40S4
Change353 from
FSYO00070
2013
Change353 to
FSYO00070
2011
Change354 from
FSYO00070
December
Change354 to
FSYO00070
May
Change355 from FSYO00070
Change355 to
FSYO00070
TBC
Change356 from FSYO00070
Change356 to
FSYO00070
existing/hip
Change357 from FSYO00070
Change357 to
FSYO00070
TBC
This is what I need – all data with the same ID in 1 row..
Change348 from FSYO00070 Tankersley YT5
EZ F40S11
Change348 to FSYO00070 Brampton N/A T70 OKA TBC
F40S4 etc

Any help whatsoever would be greatly appreciated...
Many many thanks
Paul