You can use this, change Sheet1 and Sheet2 to your source and destination
sheets respectively
Sub NewRearrangeMacro()
Dim wks As Worksheet, wks2 As Worksheet
Dim Lrow As Long, I As Long, j As Long, k As Long
Dim Colcount As Long
Set wks = Worksheets("Sheet1")
Set wks2 =
Hi Excel Group,
Please can you help me with an Excel Macro that process the entire
information saved on Sheet 1, and generates a report on Sheet 2
Sheet 1
A B C D E F G
1 Door A2 B3 C2 L1
2 furniture B2 B3
3 TV A1 A2
4 Kitchen L2 L4 Z1 M2 R3 W5
(Total rows: 500,