I do not have the ability to download files from my current location, so I cannot view your file right now.
If you could post images or samples to this thread using the "XL2BB" tool, I will be able to view it right away.
Otherwise, I will not get able to look at it until quite a bit later today (perhaps someone else may be able to download your file in the meantime).
Basically, we need to know what your data in columns B-G looks like, and how exactly do you want to combine it all into one column.
Is it a simple concatenation, cramming things together, or is there a space or some other delimiter between each value, i.e.
maybe the following will work.
For row 2, in cell A2, use the formula: =CONCATENATE(B2,C2,D2,E2,F2,G2)
Oh, I think I see what you are talking about now.
Do you mean that if column A is blank in any row, you want to shift the values from B:G over to the left one column?
If so, there are a few ways you can go about it:
1. Highlight column A
2. Press the F5 key
3. Click the "Special" button
4. Select the "Blanks" radio button
5. Hit "OK"
6. Right-click on any blank cell
7. Select "Delete"
8. Make sure the "Shift cells left" radio button is selected
9. Click "OK"
That should do it.
If you want to do it via VBA code, just turn on your Macro Recorder as you record the steps above.