How to combine data in a single column from three columns

**krjoshi** · 11-14-2011, 11:45 AM

I have a workbook with two sheets "Asset" & "Combine". How I can combine the row data in a single column from sheet "Asset" (Columns A, B & C) to sheet "Combine" (Column A) .

Please note that "Asset" Sheet (Columns A, B & C) row data will vary some times.

The workbook is attached. Please help me.

Thanks in advance.

Joshi

**jaslake** · 11-14-2011, 03:22 PM

Hi Joshi

This code appears to do as you require

Please Login or Register  to view this content.

Let me know of issues.

**krjoshi** · 11-15-2011, 12:35 PM

Hi Jaslake

Thanks for you help and its working too. One more issue i need to remove duplicate values from sheet "Combine" (Column A) if i entered any in sheet "Asset" (Columns A, B & C).

Thanks in advance.

Joshi

**jaslake** · 11-15-2011, 01:05 PM

Hi Joshi

Try this

Please Login or Register  to view this content.

**krjoshi** · 11-15-2011, 01:34 PM

Hi Jaslake

It’s working perfectly. Thank you so much.

Joshi

**jaslake** · 11-15-2011, 01:36 PM

Hi Joshi

You're welcome...glad I could help.

**krjoshi** · 11-17-2011, 12:19 PM

Dear John,

One more issue, any chance without delete "A" Column since I want to give "A" Coulmn rows reference to some other sheet. Please see the attachment for more details.

Thanks in advance.

Joshi

**krjoshi** · 11-18-2011, 01:37 AM

Dear John,

One more issue, any chance without delete "A" Column since I want to give "A" Coulmn rows reference to some other sheet. Please see the attachment in my previous post for more details.

Thanks in advance.

Joshi