Transpose data with formulas

[Firstpost]

Hi,

I have lot currency conversion data that needs to be transposed so we can load it to a DB. Due to security restrictions no macros are allowed so I will have to rely on formulas.

The existing data is in this format:

DateYearQuarterAUDCAD CurncyAUDCLP CurncyAUDCZK Curncy.............
1/1/1620161.0117 515.67318.1714
2/1/16
3/1/16

I need to convert it into this format

DateYearQuarterConversion CurrencyCurrency Value
1/1/162016AUDCAD Curncy1.0117
1/1/162016AUDCLP Curncy515.673
1/1/162016AUDCZK Curncy18.1714
1/1/162016AUDDKK Curncy5.013
1/1/162016AUDHUF Curncy211.757
1/1/162016AUDILS Curncy2.8311
1/1/162016AUDJPY Curncy88.085
1/1/162016AUDKRW Curncy855.6085
1/1/162016AUDMXN Curncy12.6062
1/1/162016AUDNZD Curncy1.0615
1/1/162016AUDNOK Curncy6.47467
1/1/162016AUDPLN Curncy2.8803
1/1/162016AUDSEK Curncy6.1776
1/1/162016AUDCHF Curncy0.7307
1/1/162016AUDTRY Curncy2.1262
1/1/162016AUDGBP Curncy0.4952
1/1/162016AUDUSD Curncy0.7303
1/1/162016AUDEUR Curncy0.6726

[IMG alt="Name: Screen Shot 2021-06-29 at 1.15.26 pm.jpg
Views: 0
Size: 164.5 KB"]Excel Help Forum

Your help is much appreciated. Thanks

 

[Firstpost]

https://file.io/jhyGyCeqfRho

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Please provide links to any other site where you have asked this question.