SQL server – In Excel (or LibreOffice Calc, in fact), how to convert a sheet containing the answers to a survey into a two-dimensional grid?

For example, if I have these data:

Name    Question                            Answer
Alice   What is your favorite color?        blue
Alice   What is your favorite video game?   Minecraft
Alice   What is your favorite number?       42
Bob     What is your favorite color?        red
Bob     What is your favorite video game?   Team Fortress 2
Bob     What is your favorite number?       7
Charlie What is your favorite color?        green
Charlie What is your favorite video game?   Candy Crush
Charlie What is your favorite number?       -1

I want it to be formatted as follows:

Name    What is your favorite color?    What is your favorite video game?   What is your favorite number?
Alice   blue                            Minecraft                           42
Bob     red                             Team Fortress 2                     7
Charlie green                           Candy Crush                         -1

Is it possible to do it in Excel or LibreOffice Calc? (Or in SQL Server, that's where the data comes from.)

freeoffice calc & # 39; c & # 39; add-in – Ask Ubuntu

I want to open a Calc worksheet that contains data, gather some values, perform calculations on these values ​​using "c" programming, and enter the results in the spreadsheet.
I downloaded and extracted the SDK 6.3. When I search the Internet for instructions on how to use the SDK to accomplish my simple and conceptual task, I find myself deep in the pool above my head.
I would appreciate a prod that would point me in a direction that could solve my problem
Thank you for all the thoughts you may have

Can we connect the postgres server to LibreOffice Calc on Ubuntu?

I want to connect the Postgres database to LibreOffice Calc under Ubuntu. Can any one say what option is used and the steps to connect it.

responsive webdesign – Css Calc () Function CPU or GPU?

I wonder if the Css Calc ()
The function is calculated or executed on the CPU or GPU
Messing around with certain styles, I've noticed that creating certain elements
using vh, vw, vmin and vmax are more nervous on a window resizing than if I'm using
Calc (12vmax + 50px). GPU animations work faster apparently,
so I wonder which one handles the calculations?
Does anyone know or refer to articles
as I do not find any?

fonts – How to disable the import option in LibreOffice Calc when pasting text into a cell?

I create a table in which I have to copy a few lines of pdf in a table. I use LibreOffice calc for making tables. The problem is that even if I copy a simple text from the PDF file, when I paste it into LibreOffice, the import option continues to display (randomly; sometimes it sometimes, and because of the font size of this pasted text, it is also very small.The desired result is that when I paste the text into the cell, it just got stuck in the cell, without loss of time, which also disrupts the size of the font.
The same question is asked here but no solution.
https://ask.libreoffice.org/en/question/1813/disable-the-import-options-dialog/

Freezing rows in Calc

Recently, rows and columns Show / Freeze Cells / Freeze do not work in Calc. Sometimes I can freeze the first line for a while, then it stops working. I would like the first and second lines to be frozen.

Application Development Cost Calculators

The mobile application development company is very competitive, with several million mobile applications on the market. It's very difficult to know how to reach your target users and how to reach your ROI goals. Companies want to find a way to calculate the average cost of developing applications right from the start. To meet this demand, different online calculators have been developed and we will highlight only the most popular ones.

Otreva calculator

This calculator was developed by Scranton, a Pennsylvania-based Otreva mobile application development company. The calculation offers statistics that cover multiple platforms, features of the application and the administrator, how much is needed to build them on average, as well as the average cost. It can also estimate the cost of development and application iOS, An, Windows Phone or even Web. It introduces users to two steps to follow when users must select a platform, then the specific features that they would like to incorporate into mobile applications, and then provides a quote in USD.

imason calculator

. Just like Otreva calc, this one is built on a structure in three stages. In the first step, users can choose between the type of application for iPhone, iPad, Phone, Phone, Tablet, Windows Phone or Windows and for the second step, choose the specific features they need to get a quote from development. for, like the connection, the social connection, the support of the second language and more.

Kinvey calculator

Unlike the previous two calculators, this one from Kinvey has more steps to follow for users and allows for a more detailed estimate of application development costs. The steps are: platform selection, internal / external team selection, use of any cloud technology, size, user management, type of data to store, choice of data sources, usage / no location data, use of third-party cloud APIs, choice of user engagement channels, and more. Once all this information is provided, users can provide their email address to also get an estimate.

Calculator of mobile applications of the company

It provides business users with many steps to provide an estimate. The steps are as follows: the B2C / B2B / B2E platform requires a type of authentic application or not (access to data from the company / reconfigure a business process / mobilize one or more new business processes), complexity AU, set of features, with the help of Push Notifications or not, number of corporate networks to connect to and more.

.

OpenOffice Calc: Extracts the whole number of channel 12 246 in Office products (see Top 100 in Office products)

I'm trying to get to
12246

of
No. 12.246 in office products (see Top 100 in office products)

in
OpenOffice Calc

Update data in imported HTML tables in LibreOffice Calc

I have a Calc freeware document, with several sheets in each sheet being imported HTML tables from different URLs. I would need to create a button to update the data in the tables of this sheet.
Example: In sheet 1, I want to use five buttons: button A updates the table data in sheet 2, button B updates the table data in sheet 3, and so on.

It is possible to do it.

thank you

How to use calc with image in a lightbox gallery

Some of your past responses have not been well received and you may be stuck.

Please pay close attention to the following tips:

  • Please make sure to respond to the question. Provide details and share your research!

But to avoid

  • Ask for help, clarification, or answer other answers.
  • Make statements based on opinions; save them with references or personal experience.

To learn more, read our tips for writing good answers.