All Questions
6
questions
0
votes
2
answers
555
views
Transpose Group of Rows to Single Row | MS EXCEL
I need to Transform Some Uneven Group of multiple rows to single row
I Tried to Extract the Required data from multiple row to multiple Column. But all data placed under different Rows (same as input ...
0
votes
2
answers
2k
views
Move data from multiple columns into one and remove duplicates
I currently have a situation wherein I require the unique data from multiple columns to be moved/identified in one single column.
The data currently looks like this:
Apple
Microsoft
Dell
U.S
U.S
...
1
vote
1
answer
3k
views
Delete Specific Rows from Excel from a List of Row Numbers
I have a worksheet with 83,188 rows and 4 columns of data.
I have another worksheet that has a list of row numbers (eg 18751, 9127, 696, and etc) that signify the rows I would like to delete from the ...
0
votes
1
answer
382
views
Extracting all matching (or close to) values between given START n-th and END n-th values / using Power Query
Consider having two tables. Table1(T1) has Date/Time and Pressure value columns and Table2(T2) has also Date/Time and Info values columns.
T1 is showing pressure change through time, for instance: 21....
0
votes
1
answer
308
views
VBA - IBAN validation not working
I have a list of IBANs in Excel and wish to validate them via scraping data through VBA from this website: https://www.iban.com/iban-checker. In column A (cells A2:A3000), I have the IBANs and in ...
0
votes
2
answers
754
views
How do I compare two columns for matching and non matching values and get it in the format that I want?
How do I find matching and non matching values between two columns and format it in the below manner?
Input:
| expected | match | forward | backward | actual |
|----------|-------|---------|---------...