Move information across columns to the First column - please help

[vivek.budhram]

Hi Team,

trust you well,

please help with the following:

I am combining a query for mysql

I am building the query around 34174 records using excel and then copy and paste into the mysql

for each column and row, i have added a value. which goes across from column A to column O
in step form of rows.

e.g
the screen shoot attached

and the excel spreadsheet ("from this" tab which is the original, "to this" tab for which i need a quick fix to move the information across to the first column )

FROM:
(
township=

ABBOTSFORD


and

postalcode=

2037

)

or


(
township=

ABBOTSFORD


and

postalcode=

2192

)

or

TO:
(
township=

ABBOTSFORD


and

postalcode=

2037

)

or


(
township=

ABBOTSFORD


and

postalcode=

2192

)

or

I will then use transpose to copy it to the first row like so:

( township= ABBOTSFORD and postalcode= 2037 ) or ( township= ABBOTSFORD and postalcode= 2192 ) or


PLEASE HELP

[samba_ravi]

Select all the data or (press Ctrl+A+A) >
Then PRESS Ctrl+G OR F5 > Special > Blank > OK > Ctrl- (Press Ctrl key and "-" key)>ShiftCells Left>OK
Try the above process

[vivek.budhram]

it wont work on mac platform

[JohnTopley]

In A1

=IFERROR(LOOKUP(2,1/('from this'!A1:ZZ1<>""),'from this'!A1:ZZ1),"")

copy down

[vivek.budhram]

ok, Thank you

Then the other question is,

I need to combine row 1, column A to GHG (5000 Columns to be exact, limited to 16,384 columns ) into one column
the sample i have in each column is as follows for which i need to copy and paste it into a mysql query:

[JohnTopley]

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[vivek.budhram]

Ok, i have attached the worksheet
i need to combine column A up to column GJG into one column, as i need to copy and paste the query on mysql. I have included all spaces and specials characters in require. just need to be able the merge them together.

Thank you in advance

Please see attached

[vivek.budhram]

Hi there

I have attached a worksheet and have an example of the output i require.

CONCATENATE wont work as there are too many instances.

Thank you in advance

[vivek.budhram]

Let me rephrase, multiple cells in the first row into one cell in the first row (horizontally)

[JohnTopley]

You are well in excess of 32767 characters in a cell.