columns arrange

Hello Excel gurus! need help in transposing data. Provide is the sample screenshot needed. Is there a way to do this thru formula or a macro is needed? Thank you so much!

Hi, I've worked all weekend to learn VBA. I came close, but code is probably what a proper coder would call (very) ugly. I would really appreciate tips on how to make a more streamlined code in addition to the key question: A rather big set of data are collected on sheet 1 ("Disorderly"). Column...

I have to combine several worksheets originally based on standard columns into a single worksheet, but users have randomly included extra columns. So for example if the original headers were: |Date|Forename|Surname|Address1|Address2|Town|Car user| Some now have additional columns inserted...

Hi Can someone help with this, I have a worksheet with 62 columns of data, I want to take every other columns data and make one column eg Column A,C,E,G until AP each column has different amount cells of data so I want it so it doesn't leave a blank space when merged to one column say column...

Hello everyone, The code below aims to copy several sets of columns and past them into another sheet. How can i say that I just want to start the information to be pasted on the column "F"? I think is something to be with the definition of my dimension "s"... thanks in advance!! Sub...

I have a macro to create a pivot table that works great except when I try to sort the Columns. I have a column called "Aging Category" with 0-7 days, 8-14 days, 15-30 days, 31-90 days, 91-180 days, and 181+ days. Not all categories will always be represented in the raw data, but want to include...

I am trying to sort exposure, largest to smallest by column K, but using the sort function isnt working. The company name is in column A, and doesnt change accordingly with the sort in K- I think this is because the data is locked via SUMIFs from other sheets. e.g...

Hi, I have data that looks like this: <tbody> A B C D 1 a b c d 2 g c d 3 h i d 4 d </tbody> and I need a formula to convert it to look like this: <tbody> A B C D 1 d c b a 2 d c g 3 d i h 4 d </tbody> (i.e. the order reversed, and the last values (as per...

Good Afternoon Guys, I have a small confusion.. I have more than 50 Excel files... that contains...Addresses for the employees of subcontracts. Example... Name Address1 Address2 City Mobile No. Joining Date Trade My problem is the above field (Columns are not in above sequence in all files...