Transpose matching data from columns to rows

[Godders199]

Hello, I have tried searching for the answer, but dont really no what to search.

Effectively i have sheet 1 and Sheet 2, sheet 1 has all the products , sale and dispatch dates, sheet 2 just lists all the products, for example A-Z

Sheet 1

Product	Name	Sale Date	Dispact date
a		20/12/2018	24/12/2018
a		20/12/2018	24/12/2018
a		20/12/2018	24/12/2018
b		20/12/2018	24/12/2018

<colgroup><col width="135" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4937;"> <col width="64" style="width: 48pt;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2"> <tbody> </tbody>

Sheet 2

Product	Dispatch date	Dispatch date	Dispatch date	Dispatch date
a	24/12/2018	24/12/2018	24/12/2018
b
c
d

<colgroup><col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;"> <col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;" span="2"> <col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;"> <tbody> </tbody>

effectively what i want to do is, on sheet2, detail all the dispatch dates or each product in a row.

If some one could tell me how to do it, i will then beable to write te vba

thanks

 

[sadboy309]

I use formula array, so you need click Ctrl+Shift+Enter end of line formula.
Formula:

{=IFERROR(INDEX(Sheet1!$D$2:$D$5,SMALL(IF(Sheet1!$A$2:$A$5=Sheet2!$A2,ROW(Sheet1!$A$2:$A$5)-1,""),COLUMN()-1)),"")}

 

[Godders199]

thanks, i was just comng back to ihad found the answer, exactly the sameas yours

 

[bwaaack]

Hi! I have a similar 2 sheet transpose from columns to rows issue. Can you help with a formula that results in sheet 2?

Sheet1

Item#	Image	URL
10011-BKBK	10011-BKBK_01.jpg	assets/images/MEM_MAIN/10011-BKBK_01.jpg
10011-BKBK	10011-BKBK_02_TABLETOP.jpg	assets/images/MEM_ALT/10011-BKBK_02_TABLETOP.jpg
10011-GRGR	10011-GRGR_01.jpg	assets/images/MEM_MAIN/10011-GRGR_01.jpg
10011-GRGR	10011-GRGR_02_FACE.jpg	assets/images/MEM_ALT/10011-GRGR_02_FACE.jpg
10011-GRGR	10011-GRGR_03_GIRL.jpg	assets/images/MEM_ALT/10011-GRGR_03_GIRL.jpg
10011-RDBL	10011-RDBL_01.jpg	assets/images/MEM_MAIN/10011-RDBL_01.jpg

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Sheet 2

Item#	image	image	image	image	image
10011-BKBK	assets/images/MEM_MAIN/10011-BKBK_01.jpg	assets/images/MEM_ALT/10011-BKBK_02_TABLETOP.jpg
10011-GRGR	assets/images/MEM_MAIN/10011-GRGR_01.jpg	assets/images/MEM_ALT/10011-GRGR_02_FACE.jpg	assets/images/MEM_ALT/10011-GRGR_03_GIRL.jpg
10011-RDBL	assets/images/MEM_MAIN/10011-RDBL_01.jpg

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>