Transposing rows with duplicate row ID to columns

Discuss the spreadsheet application
Post Reply
kcourtema
Posts: 1
Joined: Mon Nov 19, 2018 5:57 pm

Transposing rows with duplicate row ID to columns

Post by kcourtema »

Can someone tell me if it's possible to make this:
Screenshot_1.jpg
...look like this?
Screenshot_2.jpg
As you can see, there are repeated SKUs and the number of repeated values varies. I have a file with about 280,000 lines that I need to sort through.
OpenOffice 4.1.4
Windows 10 x64
User avatar
robleyd
Moderator
Posts: 5082
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Transposing rows with duplicate row ID to columns

Post by robleyd »

Your problem appears similar to this post - maybe that will help.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Post Reply