Convert Rows to Columns with values in Excel using custom format

0 votes
1

I having a Excel sheet with 1 Merged cell column and 3 subcolumns in that.So I want custom sort the columns and rows on the basis of my format. I have tried using index like this =INDEX(Full!$A$1:$AH$579,COLUMN(A1),ROW(A1)) but this not working in my case so let me the solutions

Eg. I have existing format like this (With values)
Feb 17 in Others by Edureka
• 13,640 points
62 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer

Convert Rows to columns using 'Pivot' in SQL Server

If you are using SQL Server 2005+, ...READ MORE

answered Jun 20 in Others by nisha
• 2,180 points
134 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 20,080 points
13 views
0 votes
0 answers

Convert column in excel date format (DDDDD.tttt) to datetime using pandas

I have a dataframe with multiple columns ...READ MORE

1 day ago in Others by Kithuzzz
• 11,840 points
4 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 20,080 points
12 views
0 votes
1 answer

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

answered 5 days ago in Others by narikkadan
• 20,080 points
18 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by gaurav
• 18,960 points
330 views
0 votes
1 answer

Transpose column on one sheet to row on another, with linking

select A1:J1 in worksheet B and enter: =TRANSPOSE('worksheet ...READ MORE

answered Sep 25 in Others by narikkadan
• 20,080 points
12 views
0 votes
1 answer

Transposing columns to rows in Excel

Due to the amount of your data, ...READ MORE

answered 23 hours ago in Others by narikkadan
• 20,080 points
7 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
400 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,094 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP