Answered

Google sheet multiple rows to multiple columns

(0) Share

Report

Posted on by MadW

I get data from an autogenerated Google sheet. The list looks like this where one sky could only have 1 image. But if multiple images for same Sku there are multiple rows and sku isn't even repeated.

Sku Image

10 Im10.jpg

15 Pic15.png

img15a.jpg

im15-2.png

20ab Bla.jpeg

I need 1 row for each sku with multiple columns instead. Like this

Sku Image image2 Image3

10 Im10.jpg

15 Pic15.png img15a.jpg im15-2.png

20ab Bla.jpeg

I need to output as csv or excel

Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@MadW For multiple images add same sku in your google sheet column then you can transpose your data. For transpose take help from this.

How to transpose Excel table via flow? « Gopenly

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
MadW on at

Like (0)

Report

Hi Hardesh15,
Thanks for you reply. Will try your solution, but seems to be the right way to go.

Was this reply helpful? Yes No