Need Help converting columns to YML format

**trevor2524** · 02-06-2023, 10:02 AM

Hello All,

Looking for some help on how to achieve the following. I have two sheets. In Sheet1 i have three columns (Variable, Value, Server) with various forms of data. I'm looking to transfer that data into a specific format on sheet2. It would be setup in YML format with the variable name as the main category. Then each server would be listed out with the value listed after it. Does anyone have any ideas on how i can achieve this. Your help is appreciated.VBA Example.xlsx

**alansidman** · 02-06-2023, 02:18 PM

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile indicates XL2003 yet your sample indicates a version that is at least 2007. Please update your version.
Thanks

**trevor2524** · 02-06-2023, 05:34 PM

Thank you. Updated

Need Help converting columns to YML format

LinkBack

Thread Tools

Rate This Thread

Display

Need Help converting columns to YML format

Re: Need Help converting columns to YML format

Re: Need Help converting columns to YML format

Thread Information

Users Browsing this Thread

Similar Threads

Converting Columns of Data into Data Friendly Format

[SOLVED] Converting Text Date format to MM?DD?YY Format

Mac converting excel cell formats from general format to date format

[SOLVED] Converting from a decimal format to a concatenated format

Need assistance converting times stored in date format to number format.

Converting multiple columns to rows / Converting to Panel Data

[SOLVED] Converting columns to Text format....

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions