Transpose Data

[Ruban S]

Dear All,

Please help me.

I have data like this

SHORT	LONG	NOUN	MODIFIER	ATT N1	ATT V1
BELT,A56	BELT,DESIGNATION:A56	BELT	--	DESIGNATION	A56
BELT,A57	BELT,DESIGNATION:A57	BELT	--	DESIGNATION	A57

And I want it like this

BELT,A56	BELT,DESIGNATION:A56
BELT	--
DESIGNATION	A56
BELT,A57	BELT,DESIGNATION:A57
BELT	--
DESIGNATION	A57

 

[Ruban S]

You need to change the sheet names to match your sheet names

Thank You Very much.
It is working. But it is restricted to 6 Fields(columns). What to do if I have many columns.

 

[Fluff]

It's not limited to 6 columns, as long as there are no blank columns or rows it will work for your entire data.

 

[Ruban S]

It's not limited to 6 columns, as long as there are no blank columns or rows it will work for your entire data.

Dear,

It is really helpful.

Can you please help me with the below request also.

I have data like this
CODE	NOUN & MODIFIER	SHORT	LONG	ATT N1	ATT V1	ATT V1 ABB	ATT N2	ATT V2	ATT V2 ABB
1​	BELT,--	BELT,A56	BELT,DESIGNATION:A56,MATERIAL:RUBBER	DESIGNATION	A56	A56	MATERIAL	RUBBER	RBR
2​	BELT,--	BELT,A57	BELT,DESIGNATION:A57,MATERIAL:RUBBER	DESIGNATION	A57	A57	MATERIAL	RUBBER	RBR

And I want it like this

1​	BELT,--	BELT,A56	BELT,DESIGNATION:A56,MATERIAL:RUBBER
1​	DESIGNATION	A56	A56
1​	MATERIAL	RUBBER	RBR
2​	BELT,--	BELT,A57	BELT,DESIGNATION:A57,MATERIAL:RUBBER
2​	DESIGNATION	A57	A57
2​	MATERIAL	RUBBER	RBR

 

[Fluff]

How about

Sub RubanS()
    Dim Oary As Variant, Nary As Variant
    Dim r As Long, c As Long, nr As Long
    
    Oary = Range("A1").CurrentRegion.Value2
    ReDim Nary(1 To UBound(Oary) * UBound(Oary, 2) / 2, 1 To 4)
    For r = 2 To UBound(Oary)
        For c = 2 To UBound(Oary, 2) Step 3
            nr = nr + 1
            Nary(nr, 1) = Oary(r, 1)
            Nary(nr, 2) = Oary(r, c)
            Nary(nr, 3) = Oary(r, c + 1)
            Nary(nr, 4) = Oary(r, c + 2)
        Next c
    Next r
    Sheets("Sheet2").Range("A1").Resize(nr, 4).Value = Nary
End Sub

 

[Ruban S]

Dear,

Thank you very much. It is working great.

Please help me in future also, if I need anything else.

 

[Fluff]

You're welcome & thanks for the feedback

 

[Ruban S]

Dear,

I need your help for the below request.

I have data like this

SHORT	LONG	NOUN	MODIFIER	ATT N1	ATT V1	ATT N2	ATT V2	ATT N3	ATT V3
CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT	CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML	CHEMICAL	--	TYPE		PACK SIZE
CHEMICAL,FLUSH,LOCO,236.6ML	CHEMICAL,FLUSH, BRAND:LOCO, PACK SIZE:236.6ML	CHEMICAL	FLUSH	MANUFACTURER		BRAND		PACK SIZE

I Need it like this

SHORT	LONG	NOUN	MODIFIER	ATT N1	ATT V1	ATT N2	ATT V2	ATT N3	ATT V3
CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT	CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML	CHEMICAL	--	TYPE	FAST-DRY SELF VULCANIZING CEMENT	PACK SIZE	236.6ML
CHEMICAL,FLUSH,LOCO,236.6ML	CHEMICAL,FLUSH, BRAND:LOCO, PACK SIZE:236.6ML	CHEMICAL	FLUSH	MANUFACTURER		BRAND	LOCO	PACK SIZE	236.6ML

Likewise, I have many records, Please help me with some solution.
Data has to be Autofill based on LONG

 

[Fluff]

As this is a totally different question, you will need to start a new thread.
Thanks

 

[Ruban S]

As this is a totally different question, you will need to start a new thread.
Thanks

Dear,

Please help me with this.

Auto Splitting of Data

Dear, I have data like this SHORT LONG NOUN MODIFIER ATT N1 ATT V1 ATT N2 ATT V2 ATT N3 ATT V3 CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML CHEMICAL -- TYPE PACK SIZE CHEMICAL,FLUSH,LOCO,236.6ML CHEMICAL,FLUSH...

www.mrexcel.com