columms

Hi, Required a formula help for Filter/Transpose a multiple rows and multiple columns in a same row as per condition met with row headers . Row Headers that contain duplicate row headers and reorder all values or text values from multiple columns into one row. solution to be needed in Column...

Name code Size in cm Weight in kg Age Gender M/f kg/cm size/age weight/age Persons Andrew Black P001 180 82 23 M 0.46 7.83 3.57 Sarah Jones P002 169 71 32 F 0.42 5.28 2.22 Tim Bradford P003 175 71 45 M 0.41 3.89 1.58 Julie Clark P004 172...

Hello, I'm looking for a way, preferably Power Query, to have a sheet with a table or text file with column names that are visible when loading a spreadsheet. For example I have a csv with the following columns: <colgroup><col></colgroup><tbody> Caption IP_Address AgentPort...

Hi there, I have data in multiple columns on Sheet "Fields" - from A-AS. Each column varies in data and has 1-100 rows populated. I wish to take all this data from these columns and paste them into one column on the "Sheet3" tab. On the fields tab there is a header row which I do not require...

<tbody> Ref Company Date Company INV Number Sub Total Expenses Difference Grand Total Paid Credit Status Date Sum Outstanding Amount Sum by Date 1 Test 2018/10/03 Test 2018/10/03_Test0001 Test0001 R3 888,00 R2 110,00 -R 4 002,00 R 5 998,00 Yes OPEN -R 4 002,00 0,00 43377 43376 2 test...

Hi I hope you can help me. The following macro works but it also deletes columms that partly contains the string its searching for. 'Sub Remove_columns() ' Dim wS As Worksheet ' For Each wS In ThisWorkbook.Worksheets ' With wS ' For i = .Columns.Count To 1 Step -1 '...