Solved

Excel 2020 Transform format 140417

Posted on 2014-04-17
3
239 Views
Last Modified: 2014-04-18
ServerBuild template Imprt SetServer Template Imprt setServer Template Imprt setGood afternoon expert,

I searched for an answer to a similar question in the knowledge base. One was pretty
close, I think, but it was in Chinese so I am not sure.

The System Engineers input the info in the screen shot with the title 'Server Build Specifications'. The information is formatted vertically.

The Configuration Management DB is in a app called ServiceNow and ServiceNow wants
to import the information as an import set that is formatted horizontally like the one in the spreadsheet with the blue header and white letters: HostName, IP Address, Additonal IP Address..."

Would like to write a macro that would take the fields in the vertical format and rewrite it in a horizontal layout.

What is the best way to do this?

Thanks.

Allen in Dallas
0
Comment
Question by:9apit
3 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 40007906
Allen,

This is entirely feasible.  However, to make sure we fully answer the question, we really need you to post samples of the files themselves.

The data in the files can be fake.  What is important is that they be structurally the same as the real files, and that they demonstrate the expected output given specific sample input.

Patrick
0
 
LVL 13

Expert Comment

by:akb
ID: 40008037
Do you really want a macro to do this or is it a one off?

If you want to do it manually then you just need to highlight the cells, copy them, then right click where you want them to go, select Paste Special, tick the Transpose tick box and clink OK.

If you want a macro, go to the Developer tab and press Record Macro.
0
 

Author Closing Comment

by:9apit
ID: 40008606
Actually I figured out that I could make the cells in the second worksheet formulas
that were equal to the cells in the first worksheet and avoid writing a macro. Thanks.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now