column consolidation

Hello to All! I have a data with more than 500 columns in excel xlsx file. the columns are like this: A1 A2 A3... A15 B1 B2.... B15 C1 C2 C15... and so on. I like to relocate columns in such a way that it is A1B1C1D1...then A2B2C2...etc. Is there a macro that can do this relocation. Since...

I have a excel file with the following column , it needs to be segregated into date and month , but at some cells the format is different For eg : 19-Jan , and in some cells its Feb-36. I tried using text to xolumns funtions & delimiter , but couldnt get the result . Can you please help me out...

Hi, I have two columns of data in excel. There is no common values between these two columns. Few values in column1 is mapped manually with values in column2. Now i need to display both columns with mapped and non mapped values. I attached a sample sheet with this. Thanks Regards, Kannan S...

Consider the following data set: <tbody> Month Product Unit Price Sales Volume Revenue Discount % Discount Value Jan A 5 10 50 5% 2.5 Feb A 5 15 75 5% 3.75 Mar A 5 20 100 5% 5 Apr A 5 25 125 5% 6.25 May A 5 30 150 5% 7.5 Jun A 5 35 175 5% 8.75 Jul A 5 40 200 5% 10 Aug A 5 45...

Good Afternoon everyone! Had a quick questions on column combinations. I'm working with a table of serial numbers, and wanted to merge Column C with Column B without breaking the previous data association. Here's a screenshot of what I'm working with: Would love to combine Columns B & C...

Good Morning Excel Gurus! Currently I'm working on creating a master inventory spreadsheet. I have a table with computer names associated with ports, location, etc. I want to merge another computer name column with my 1st column WHILE preserving the data (ports, location, etc.) The ideal...

When I get a report out of the system, “column a” should have all the names, instead it is first few rows name is in “column a”, then it is in “column b” then in “column c” and so on…. So I want to add a column before “column a” and in the “new column a” I want to get data from all the other...

I'm not an advanced VBA programmer. I'm working on an excel macro which will allow me to select a range(using input box) to clean the data(makes consistent with mySQL schema) on worksheet. I get this file from anther team and 1.) the order of columns is not fixed 2) levels of...