Normalization in excel

[chethan av]

Hi guys
I want to build VBA code for normalization

if the data is populated in excel like this( 4 columns)

a h o v
b i p w
c j q x
d k r y
e l s z
f m t a
g n u b



i need to rearrange the data like given below

a h a h
b i b i
c j c j
d k d k
e l e l
f m f m
g n g n
o v o v
p w p w
q x q x
r y r y
s z s z
t a t a
u b u b

Please give a solution guys

 

[jmacleary]

Welcome. Try this macro:

Option Explicit

Sub Shifter()


    Dim LastRow As Long
    Dim Rw As Long
    LastRow = Range("A65536").End(xlUp).Row
    For Rw = 1 To LastRow
        Cells(LastRow + Rw, 1) = Cells(Rw, 3)
        Cells(LastRow + Rw, 2) = Cells(Rw, 4)
        Cells(LastRow + Rw, 3) = Cells(Rw, 3)
        Cells(LastRow + Rw, 4) = Cells(Rw, 4)
        Cells(Rw, 3) = Cells(Rw, 1)
        Cells(Rw, 4) = Cells(Rw, 2)

    Next Rw
End Sub

 

[chethan av]

Welcome. Try this macro:

Option Explicit

Sub Shifter()


    Dim LastRow As Long
    Dim Rw As Long
    LastRow = Range("A65536").End(xlUp).Row
    For Rw = 1 To LastRow
        Cells(LastRow + Rw, 1) = Cells(Rw, 3)
        Cells(LastRow + Rw, 2) = Cells(Rw, 4)
        Cells(LastRow + Rw, 3) = Cells(Rw, 3)
        Cells(LastRow + Rw, 4) = Cells(Rw, 4)
        Cells(Rw, 3) = Cells(Rw, 1)
        Cells(Rw, 4) = Cells(Rw, 2)

    Next Rw
End Sub

Hi,
Thanks for the reply

But if the user has to select the range of data

and is should neglect the empty cell(means it should not copy both the cells) and it should go to the next data presenr in the next row

can help with this

 

[chethan av]

User has to select the range of data

and is should neglect the empty cell(means it should not copy both the cells) and it should go to the next data presenr in the next row

can help with this

 

[chethan av]

i will share a photo

 

[chethan av]

if the given data is like this then the output should be like what it has show in the 2nd image

 

[chethan av]

output of the image

 

[chethan av]

 

[chethan av]

unique Id is assigned for every single row by us when its created.
if the data is taken from that particular row it should also take the from which product code row it has fetched it and reflect the same product code column B

 

[chethan av]

Please give me a solution guys for the above

thanks