3000 column of data, which will transform into rows

Hi,

i have this heart burning issue where i'm trying to have my data into a single row.
Attached is the spreadsheet where i've separated into 2 sheets, (before & after)

Cheers.

What data should be copied?

In your sample spreadsheet, you seem to skip some of the data but not clear what should go in and what should be skipped.

Also in what order? by columns, or by rows, another order?

Can you clarify?

Hi Sai80,

Thanks for getting back. Yes i can clarify.

I've attached a new document for clarifications.

Requirements:
Cell A1:A11 is duplicate, therefore i would only need A1 in the "after" sheet.
Cell B1:A11 is different data, therefore it would like to have it transposed into cell b2 in "after" sheet without the empty cells.
Column C to H should also be transposed into column Q to T in "after" sheet


i would like this to happen for the next 3000 data and so on.

Please let me know if this is feasible for you!

Cheers

Hi,

would anyone be able to help me ?

Try

Please Login or Register  to view this content.

Hi Jindon,

Thanks for the prompt replies.

The first data is coming out right in "after" sheets. However the data from A12:H22 is not coming out in the "after" sheets.
Would your codes be able to "notice" the different data by using column H as i have 3000 data.

Cheers,
Glen

If the first one is correct and the 2nd one is not, I don't understand what you are trying to do.

If you show me the EXACT result for the 2nd one, it may help.

Sure,

Attached

Still not clear to me though.
If this is not working as you expect, you need to upload the more realistic data and the results.

Please Login or Register  to view this content.

Hi Jindon,

Thanks for the prompt replies, Really appreciate it.

in the after sheets, The data K1:P2 is correct!

However, for G1:J2 is not.

note that Cell A1 & A2 in 'after' sheet is from A1 & A12 in before sheet.

I've also attached an updated one.

Cheers,
Glen

Try change to

Please Login or Register  to view this content.

Hey Jindon,

Still not what i wanted.

I've revamped and made a more understandable worksheet.Hope it helps

P/S: Also take note that in "before" sheet, the data of Column E sometimes has is dynamic.

Attached.

Cheers,
Glen

You initially said,

Originally Posted by gcycglen

Requirements:
Cell A1:A11 is duplicate, therefore i would only need A1 in the "after" sheet.
Cell B1:A11 is different data, therefore it would like to have it transposed into cell b2 in "after" sheet without the empty cells.
Column C to H should also be transposed into column Q to T in "after" sheet

Now

Originally Posted by gcycglen

P/S: Also take note that in "before" sheet, the data of Column E sometimes has is dynamic.

How do you expect someone to understand above without it???

I will not write a code under my guess anymore, so explain what you are really trying to in WORDS, step by step.
If you don't want to do it, just forget about my codes.

Sorry for the confusion.

i'm not very good at words, please pardon me.

I'll try my very best to explain, Here it goes:


First data in before sheet is from A1:H12, Followed by 2nd: A12:H12, and 3rd: A23:H23, 4th: A36:H36 and so on.
The columns of those data are not the same for each data. Therefore, using Column C as a references to differentiate different data.

I do want it to be in a single column in before sheet, where we start with A1, followed by transposing (B1:B11), C1,D1,E1, (F1:F11), (G1:G11) and H1.
the 2nd data should capture the differences by using C1 as references and doing the same thing as mentioned above.

Please let me know if you understand this.

Cheers,
Glen

I'm not good at English as I speak Japanese.
But when you ask this kind of question, you need to give us as many information as you can, so that we understand what you are really trying to do.
That is your responsibility, because YOU are the only one who knows it.
If you ask like this in business, you will be charged double or triple of the initial estimated cost sometimes.

Now your "before" sheet has different column references, so this only works for the latest workbook.

Please Login or Register  to view this content.

Hi jindon,

The thanks for the code.

The first lines work, however when it reaches 2nd data, and error pops up and prompts: "Run-time Error 13, Type mismatch.

did i do something wrong ?

Do you want to fill col.A like you had or change the code to work on the latest workbook that has only one unique value?

I'm getting tired of this...