Excel data conversion from column to row

Hi

My problem is that :

I have a large number of rows that are just shown below row-wise. What I want to do is column-wise conversion. No sort wanted.


type value1 date1 value2 date2 value3 date3
kk1 100 1.1.2019 200 02.02.2019 300 03.02.2019
kk1 100 1.3.2019 200 02.03.2019 300 03.04.2019
kk2 100 1.1.2019 200 02.02.2019 300 03.02.2019
kk1 100 1.3.2019 200 02.03.2019 300 03.04.2019
kk2 100 1.1.2019 200 02.02.2019 300 03.02.2019



wanted format.( no space needed between rows, is just to be clear view.)


type value(s) date(s)
kk1 100 (value1) 1.1.2019 (date1)
kk1 200 (value2) 02.02.2019 (date2)
kk1 300 (value3) 03.02.2019 (date3)

kk1 100 (value1) 1.3.2019 (date1)
kk1 200 (value2) 02.03.2019 (date2)
kk1 300 (value3) 03.04.2019 (date3)

kk2 100 so on.. 1.1.2019 so on..
kk2 200 02.02.2019
kk2 300 03.02.2019

kk1 100 1.3.2019
kk1 200 02.03.2019
kk1 300 03.04.2019

kk2 100 1.1.2019
kk2 200 02.02.2019
kk2 300 03.02.2019

Hello iincitr and Welcome to Excel Forum.
I believe the following does what you want:
1. For the type use: =IFERROR(INDEX(A$2:A$6,ROUNDUP(ROWS(A$1:A1)/3,0)),"")
2. For the values use: =IFERROR(INDEX(B$2:G$6,ROUNDUP(ROWS(A$1:A1)/3,0),MOD(1+2*(ROWS(A$1:A1)-1),6)),"")
3. For the dates use: =IFERROR(INDEX(B$2:G$6,ROUNDUP(ROWS(A$1:A1)/3,0),MOD(1+2*(ROWS(A$1:A1)-1),6)+1),"")
For future reference you will usually get faster responses if you upload a sample workbook by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.