Hi Excel Wizards, I got an inventory to be reformated Input: Product A Variation A1 Price A1 Variation A2 Price A2 Variation A3 Price A3 ... Mr. West that was neat! great info..
I have 2 columns. I need to create a new table which displays only the unique cells in column A, but column B broken out into a listed/matched row. Please see example attached (current is table A, I want a way to create Table B). Thank you...
I have a request here as I'm a beginner to SQL so can you please take column (fields) from my excel attachment and prepare a code for me to transpose the whole table using the dummy data I have provided in the attachment. It would be great help. Thank you very much. Deepak Sharma ...
Hello! I am trying to put this data Into the format of the attached file. Essentially I need to change Coloumn "Plan_Name" into unique headers as the template asks, but I do not know how to move the adjacent cells of the plan name as the template asks without having to copy and pas...
Good day! I have a MS Excel spreadsheet with lots of rows (records) and about 8 columns. I need to extract all the rows if the value in a certain column...
:ExcelGeneral":{"__typename":"Forum","id":"board:ExcelGeneral","entityType":"FORUM","displayId":"ExcelGeneral","nodeType":"board","depth":4,"conversationStyle":"FORUM","title":"Excel","description":"Your community for how-to discussions and sharing best practices on Microsoft Excel. ...
Hello, I am trying to transpose data for employees. The data is per person for different types of insurance they have. I am trying to match our reports with the report we get from the insurance c...Show More excel Like 0 Reply View Full Discussion (4 Replies) mathetes Silver Contributo...