John Langham-Service
Member
Members
Forum Posts: 59
Member Since:
July 17, 2018
July 17, 2018
Offline
Hi Guys,
I have just been thrown a googly from one of our suppliers they're using a new system that stacks csv file as in the example when you do a multiple download, I know how to get the header information out and combine with the detail on a normal single download one but not one that's stacked like this.
I have highlighted the info I need and saved as an xls although it downloads as a csv.
First line in red needs to be filtered as Confirmation or Amendment header detail in green needs to be added to the line detail in blue.
There can be up to 12 depot/PO headers (green) and 15 product lines (blue) for each header.
I hope someone can help 🙂
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Nicole White
Adrian Macleod
Ed Norris
manoj Ka
Chris Cowan
Pawel Ganczarski
Molly King
Faraz Rafi
Anthony Blake
Jackb57
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30127
Member Stats:
Guest Posters: 49
Members: 33678
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —