Excel macro to delete blanks

[rshnkmr39]

I have data like this

Master item
039 22 36 which is in bold and component item under the same
039 15 12
039 10 52
039 10 45
039 08 45

i want it in the format mentioned below
Master item Component item
039 22 36 039 15 12
039 22 36 039 10 52
039 22 36 039 10 45
039 22 36 039 08 45

The number of components under each master item could vary and there are 2 lines of gap followed by next set of master and component items

i want the data in the format mentioned above.

Thanks in advance

[rshnkmr39]

The master item is always in Bold followed by component items under it(the number could vary).. followed by 2 lines of space and next of master item and component items

[Bhuvi]

Hi,

for a manual approach you can use the formula

Please Login or Register  to view this content.

where A1 is the master field and A2,A3... are components, just drag the formula,
You can change A1 when the master changes

[ragulduy]

Please Login or Register  to view this content.

Assuming that "039 22 36" is in column A and not spread across three columns.

[rshnkmr39]

Hi, 039 22 36 are in 3 different columns

[rshnkmr39]

The department class n item needs to be concatenated as hey are in 3 different columns..the desired output can be displayed from column n

[ragulduy]

Please Login or Register  to view this content.